---
title: TableStyles.Add Method (Excel)
keywords: vbaxl10.chm841074
f1_keywords:
- vbaxl10.chm841074
ms.prod: excel
api_name:
- Excel.TableStyles.Add
ms.assetid: 90f8f3ff-91e5-c2c5-f3c6-b19ec174270f
ms.date: 06/08/2017
---


# TableStyles.Add Method (Excel)

Creates a new  **[TableStyle](tablestyle-object-excel.md)** object and adds it to the collection.


## Syntax

 _expression_ . **Add**( **_TableStyleName_** )

 _expression_ A variable that represents a **TableStyles** object.


### Parameters



|**Name**|**Required/Optional**|**Data Type**|**Description**|
|:-----|:-----|:-----|:-----|
| _TableStyleName_|Required| **String**|The name of the table style.|

### Return Value

TableStyle


## See also


#### Concepts


[TableStyles Object](tablestyles-object-excel.md)

